Automating all testing is impossible. Moreover, not all tests should be automated. Some tests are indeed better off being conducted manually. In general though, deciding which tests should be manual and which should be automated will depend on the frequency with which a given test needs to be run and how much data is involved.
